ElectronicBenefitsTransferTender

Entity Definition

Logical Name : ElectronicBenefitsTransferTender
Physical Name : TR_LTM_EBT_TND

A sub-type of TenderLineItem that records details of FoodStamps certificates that were tendered as part of the transaction. This entity also covers non SNAP debit cards.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
FederalID The unique identifier for the FoodStamps program from which the tendered FoodStamps originated, as assigned by the United States Federal Government. ID_FDL Name varchar(40)
SerialNumber The serial number on the particular FoodStamps voucher that is being tendered. UN_SRZ Name varchar(40)
ChangeAmount The amount of change being returned to the Customer from this tender line item. This number may have to be reported upon to the government so it is recorded separately. MO_CHG MoneyShortRetail decimal(7,2)

Relationships

Parent Entity Verb Phrase Child Entity
CreditDebitCardTenderLineItem can be a ElectronicBenefitsTransferTender

Logical Views containing ElectronicBenefitsTransferTender

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 07040 - Customer Segment Dependent Behavior